SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Move-in ready and fully remodeled, this 3-bedroom, 2-bathroom Raised Ranch offers modern comfort with thoughtful upgrades. Recent improvements include a new asphalt roof (2024), mini-splits (2023), and custom kitchen with quartz countertops, ample cabinetry, and a spacious island. Additional upgrades include luxury vinyl plank flooring, a new PEX plumbing, a new hot water heater, relined chimney, and refurbished pellet stoves. The main level has three bedrooms and an updated full bathroom, while the lower level offers three flexible rooms—ideal for an office, playroom, or gym—plus a newly updated bathroom. OPEN HOUSE Tuesday April 1 4-6pm.
Description:So, you're probably wondering about the whole "location, location, location" thing in real estate, right? Well, this place totally nails it! Just a hop, skip, and a 15-minute drive away from Dartmouth University and Dartmouth Hitchcock Hospital, this sweet home is calling out for someone to make it their own. It's like it's sitting there waiting for you to throw some elbow grease and love into it, and boom, you've got yourself a real gem. Now, imagine a house with an open layout that's begging for a little bit of your creative flair. Picture big ol' bedrooms that could fit a king-sized bed with room to spare, and windows that offer views that'll make you want to sit back with a cup of joe and just take it all in. Oh, and let's not forget about that monster of a barn! It's like the ultimate man cave/she shed/playhouse for the kids/party spot all rolled into one. Plus, it comes with some extra outbuildings, so you'll have enough space to store all your toys, tools, or whatever else you can think of. You're looking at over 6 acres of pure fun. You can roam around outside, build some forts, throw a frisbee, or just kick back and enjoy the fresh air. If you're feeling adventurous, you can strap on your hiking boots or fire up the ATV/snowmobile and hit the trails, which are just a 2-minute stroll from your doorstep.
Description:Motivated Seller! Offers Deadline Sunday 6pm. This well maintained Cape home is nestled on a beautiful lot in a highly sought-after neighborhood in the heart of West Lebanon. As you step inside, you're greeted by a warm and inviting atmosphere that extends throughout every room. The first floor features an open-concept kitchen and dining area, seamlessly flowing into a bright and airy family/living room, along with a convenient half-bath. Upstairs, you'll find four bedrooms and a full bath, providing ample space for family, guests, or a home office. Beautifully maintained hardwood floors enhance the home's charm and character. On warm summer days, relax in the enclosed porch or step outside to enjoy the beautifully landscaped backyard. The spacious mudroom, located off the back entrance, leads to both the two-car garage and the backyard oasis. Whether you have a green thumb, enjoy outdoor activities, or simply want to unwind on the patio while listening to the gentle sounds of the man-made fountain, this space offers endless possibilities. The large basement provides plenty of storage and potential for future expansion—transform it into a home gym, private workshop, or additional finished living space. Situated in a prime location, this home is close to the Little League Field, shopping centers, and offers quick access to Hanover and surrounding amenities. A rare find, this move-in-ready home is perfect for full-time living.
Description:Great house! Great Location! And Energy Efficient to boot! This sun drenched contemporary raised ranch makes living in the Upper Valley simple and easy. The thoughtfully designed interior offers an option of one floor living that capitalizes on the bank of western facing windows capturing not only the warmth of the sun but also stunning lake and mountain views. The home is turnkey and ready to move into with a beautifully renovated open kitchen/ dining /living area outfitted with new appliances and new windows, as well as, 2 generous bedrooms, an office, and full bath and laundry all on the main level. The lower level is complete with a bright and airy family room with Woodstock Soapstone wood stove, a bonus/bedroom, full bath, workshop and plenty of storage. This floor walks directly out to your own private oasis of lovely gardens, prolific blueberry bushes and views of Mascoma Lake. Additionally, the home includes an oversized 2 car garage with EV plug, 2 decks and is equipped with new central AC and solar panels installed on the roof with net metered electricity providing maximum energy efficiency.. The property can be purchased alone or in combination with the lakefront camp across the road providing for a wonderful year round lakefront experience. Open House Sat 4/12 9-11 and Sun 4/13 11-1
Description:Classic West Lebanon new englander in great location! This house has SO much to offer! Great spaces - including eat-in kitchen, playroom with slider to the deck and renovated 3/4 bathroom, den and formal living room combination. Upstairs you will find 3-4 bedrooms and a renovated full bathroom including a gorgeous primary bedroom with new wood floors and walk in closet. Attic is finished and would be great for a playroom, office or guest bedroom. House has had lots of updates - new roof, renovated laundry room, newer appliances, refinished wood floors, newly paved driveway - and more! Showings start with Open House Saturday, April 5th 10:00-12:30 and Sunday, April 6th 1:00-3:30.
Description:This well-maintained and beautifully updated two-level condominium offers comfortable, stylish living with convenient access to downtown Hanover. The main floor features a spacious living and dining area that opens onto a covered balcony, providing scenic views of Girl Brook and the surrounding woodland. The light-filled, efficient galley kitchen includes a large pantry closet for ample storage. A versatile main-level bedroom can easily serve as a home office, guest room, or den. Upstairs, you will find two additional bedrooms, one with a walk-in closet, a full bath, and a laundry room. Enjoy direct access to local walking and cross-country ski trails right from your doorstep. The proximity to downtown Hanover and Dartmouth College ensures easy access to shops, restaurants, and cultural events. Residents also benefit from a recently renovated in-ground pool and clubhouse. This condo offers a perfect blend of comfort, convenience, and direct trail access in the heart of Hanover.
Description:HUGE PRICE REDUCTION! Abundant Sunshine fills this 2017 Colonial situated on 1.75 acres offering 4 bedrooms, open concept layout, sunshine galore makes your living space bright and inviting, gleaming hardwood floors, convenient 1st floor living w/laundry, 3/4 bath & bedroom, 2nd floor offers 3 bedrooms, a full bath and great closet space everywhere. The attached oversized 2 car garage flows seamlessly into the heated entry room with abundant storage affording ease with the comings and goings that your busy day entails. The lower level is impressive with it's high ceilings, easy expansion possibilities, Buderus propane boiler and spray foamed for add'l heat efficiency. The detached barn screams quintessential New England and offers two levels for game room, "toy" storage, third car garage or hey, why not rent the bay for seasonal storage and extra income. All this and a commuters dream! A hop & a skip to Mascoma Lake and only 1 mile to I-89 for easy access to Dartmouth Hitchcock Hospital and all Upper Valley Amenities.
Description:Ideal Hanover location! Less than 10 minutes to Dartmouth's campus, Dartmouth Health, and all of the fantastic amenities both Hanover and Lebanon have to offer. Fully renovated in 2018, this warm and inviting 2 bedroom, 2 bathroom home offers the ease of low maintenance condominium-like living, without the HOA fees. The main floor includes a spacious, vaulted ceiling living/dining area that opens to the kitchen (fully equipped with stainless steel appliances and soapstone countertops), bedroom/office, full bathroom, and laundry. On the second floor you'll find a large, loft-style, primary en-suite bedroom with an oversized closet. Renovation upgrades include, but are not limited to: windows, flooring, heating system, kitchen, baths and insulation. The full, unfinished basement and attached exterior shed offer ample storage space. During the warmer months, enjoy entertaining on the deck while overlooking lovely views of the Vermont mountains. Icing on the cake - despite it's wonderful, private setting, it's still on town sewer! Furnishings are digitally staged.
Description:Step into history at The Treetops, an extraordinary 4-bedroom, 2-bath home that was once part of the original Saint-Gaudens estate. This stunning property carries the spirit of the famed Cornish Art Colony, where master sculptor Augustus Saint-Gaudens and his creative circle found inspiration in the rolling hills of New Hampshire. Perched on a scenic private lot, this home offers a tranquil retreat surrounded by nature. A gentle stream winds through the property, adding to the peaceful ambiance, while garden spaces provide the perfect setting for cultivating beauty—just as artists once did in this very landscape. From the sun-drenched rooms to the charming historic details, The Treetops is a timeless escape that seamlessly blends past and present. Located just minutes from the Upper Valley, with easy access to both sides of the Connecticut River, this home offers the perfect balance of seclusion and convenience—close to Dartmouth College, world-class healthcare, vibrant arts, and year-round outdoor recreation. This is more than just a home; it's a living piece of history in one of New Hampshire’s most picturesque and storied communities. Opportunities like this are rare—don’t miss your chance to own a legacy!
Description:Charming 2-bedroom Bungalow, thoughtfully updated, and ideally located near Dartmouth Hitchcock Medical Center and downtown Hanover. This home is perfect for those seeking a low-maintenance lifestyle with a small footprint, offering the benefits of single-family living. Situated in a desirable Hanover neighborhood, you'll enjoy your own backyard space featuring a firepit and a small patio, perfect for outdoor dining in the summer. A small back deck provides space for a grill, while a lovely three-season room overlooks the yard. Inside, the beautifully updated kitchen boasts cherry countertops, plenty of storage, a farmhouse sink, and a two-seat peninsula bar. The open living and dining area flow seamlessly from the kitchen, and there are two comfortable bedrooms and a tastefully appointed full bath. The basement offers versatile space for storage, utilities, a workbench, and laundry, plus room for one small car to park. It's been spray foamed for improved energy efficiency. This home has served as both a full-time residence and a reliable source of rental income for the owners over the years. Showings begin Saturday, April 19th at the open house 9:30am-12pm.